import xlwt
import xlrd

readbook = xlrd.open_workbook(r'县.xls')
sheet = readbook.sheet_by_index(3)  # 索引的方式，从0开始
nrows = sheet.nrows  # 行
names = []

for i in range(nrows):
    name = sheet.cell(i, 2).value  # 获取i行3列的表格值
    names.append(name)
print(names)
